SherbyNet - /page/wikibook/entry.mu

Micron Document

<!DOCTYPE html>

<title>SQL Anywhere</title>

</head>

<span id="openzim-page-title" class="mw-page-title-main"><span class="mw-page-title-main">SQL Anywhere</span></span>

</h1>

</header>

/* start https://en.wikipedia.org/ */

.mw-parser-output .hatnote{font-style:italic}.mw-parser-output div.hatnote{padding-left:1.6em;margin-bottom:0.5em}.mw-parser-output .hatnote i{font-style:normal}.mw-parser-output .hatnote+link+.hatnote{margin-top:-0.5em}@media print{body.ns-0 .mw-parser-output .hatnote{display:none!important}}

/* end https://en.wikipedia.org/ */

</style><div role="note" class="hatnote navigation-not-searchable">This article is about the database. For the corporate division, see <a href="Sybase_iAnywhere" title="Sybase iAnywhere">Sybase iAnywhere</a>.</div>

<div role="note" class="hatnote navigation-not-searchable">"Sybase ASA" redirects here; not to be confused with <a href="Sybase_ASE" class="mw-redirect" title="Sybase ASE">Sybase ASE</a>.</div>

/* start https://en.wikipedia.org/ */

.mw-parser-output .ambox{border:1px solid #a2a9b1;border-left:10px solid #36c;background-color:#fbfbfb;box-sizing:border-box}.mw-parser-output .ambox+link+.ambox,.mw-parser-output .ambox+link+style+.ambox,.mw-parser-output .ambox+link+link+.ambox,.mw-parser-output .ambox+.mw-empty-elt+link+.ambox,.mw-parser-output .ambox+.mw-empty-elt+link+style+.ambox,.mw-parser-output .ambox+.mw-empty-elt+link+link+.ambox{margin-top:-1px}html body.mediawiki .mw-parser-output .ambox.mbox-small-left{margin:4px 1em 4px 0;overflow:hidden;width:238px;border-collapse:collapse;font-size:88%;line-height:1.25em}.mw-parser-output .ambox-speedy{border-left:10px solid #b32424;background-color:#fee7e6}.mw-parser-output .ambox-delete{border-left:10px solid #b32424}.mw-parser-output .ambox-content{border-left:10px solid #f28500}.mw-parser-output .ambox-style{border-left:10px solid #fc3}.mw-parser-output .ambox-move{border-left:10px solid #9932cc}.mw-parser-output .ambox-protection{border-left:10px solid #a2a9b1}.mw-parser-output .ambox .mbox-text{border:none;padding:0.25em 0.5em;width:100%}.mw-parser-output .ambox .mbox-image{border:none;padding:2px 0 2px 0.5em;text-align:center}.mw-parser-output .ambox .mbox-imageright{border:none;padding:2px 0.5em 2px 0;text-align:center}.mw-parser-output .ambox .mbox-empty-cell{border:none;padding:0;width:1px}.mw-parser-output .ambox .mbox-image-div{width:52px}@media(min-width:720px){.mw-parser-output .ambox{margin:0 10%}}@media print{body.ns-0 .mw-parser-output .ambox{display:none!important}}

/* end https://en.wikipedia.org/ */

</style>

/* start https://en.wikipedia.org/ */

.mw-parser-output .infobox-subbox{padding:0;border:none;margin:-3px;width:auto;min-width:100%;font-size:100%;clear:none;float:none;background-color:transparent}.mw-parser-output .infobox-3cols-child{margin:auto}.mw-parser-output .infobox .navbar{font-size:100%}@media screen{html.skin-theme-clientpref-night .mw-parser-output .infobox-full-data:not(.notheme)>div:not(.notheme)[style]{background:#1f1f23!important;color:#f8f9fa}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .infobox-full-data:not(.notheme)>div:not(.notheme)[style]{background:#1f1f23!important;color:#f8f9fa}}@media(min-width:640px){body.skin--responsive .mw-parser-output .infobox-table{display:table!important}body.skin--responsive .mw-parser-output .infobox-table>caption{display:table-caption!important}body.skin--responsive .mw-parser-output .infobox-table>tbody{display:table-row-group}body.skin--responsive .mw-parser-output .infobox-table th,body.skin--responsive .mw-parser-output .infobox-table td{padding-left:inherit;padding-right:inherit}}

/* end https://en.wikipedia.org/ */

</style><table class="infobox vevent"><tbody><tr><th colspan="2" class="infobox-above summary">SQL Anywhere</th></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="Programmer" title="Programmer">Developer(s)</a></th><td class="infobox-data"><a href="SAP_AG" class="mw-redirect" title="SAP AG">SAP</a></td></tr><tr style="display: none;"><td colspan="2" class="infobox-full-data"></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="Software_release_life_cycle" title="Software release life cycle">Stable release</a></th><td class="infobox-data"><div style="margin:0px;">17.0

</div></td></tr><tr style="display:none"><td colspan="2">

</td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="Software_categories#Categorization_approaches" title="Software categories">Type</a></th><td class="infobox-data">Database</td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="Software_license" title="Software license">License</a></th><td class="infobox-data">proprietary license</td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;">Website</th><td class="infobox-data"><span class="url"><a rel="nofollow" class="external text" href="https://www.sap.com/products/sql-anywhere.html">www<wbr>.sap<wbr>.com<wbr>/products<wbr>/sql-anywhere<wbr>.html</a></span></td></tr></tbody></table>

<p><b>SAP SQL Anywhere</b> is a proprietary <a href="Relational_database_management_system" class="mw-redirect" title="Relational database management system">relational database management system (RDBMS)</a> product from <a href="SAP_AG" class="mw-redirect" title="SAP AG">SAP</a>. SQL Anywhere was known as <b>Sybase SQL Anywhere</b> prior to the acquisition of <a href="Sybase" title="Sybase">Sybase</a> by SAP.

</p>

<div class="mw-heading mw-heading2"><h2 id="History">History</h2></div>

<p>The database company <a href="Sybase" title="Sybase">Sybase</a> obtained the SQL Anywhere technology as part of its acquisition of <a href="PowerBuilder" title="PowerBuilder">PowerBuilder</a> vendor PowerSoft.<sup id="cite_ref-rdbmsingressybase20070613_1-0" class="reference"><a href="#cite_note-rdbmsingressybase20070613-1"><span class="cite-bracket">[</span>1<span class="cite-bracket">]</span></a></sup>

</p>

<div class="mw-heading mw-heading2"><h2 id="Features">Features</h2></div>

<p>SQL Anywhere can be run on <a href="Microsoft_Windows" title="Microsoft Windows">Windows</a>, <a href="Windows_CE" title="Windows CE">Windows CE</a>, <a href="Mac_OS_X" class="mw-redirect" title="Mac OS X">Mac OS X</a>, and various <a href="UNIX" class="mw-redirect" title="UNIX">UNIX</a> platforms, including <a href="Linux" title="Linux">Linux</a>, <a href="AIX" class="mw-redirect" title="AIX">AIX</a>, <a href="HP-UX" title="HP-UX">HP-UX</a> and <a href="Solaris_(operating_system)" class="mw-redirect" title="Solaris (operating system)">Solaris</a>. Database files are independent of the <a href="Operating_system" title="Operating system">operating system</a>, allowing them to be copied between supported platforms. The product provides several standard interfaces (<a href="ODBC" class="mw-redirect" title="ODBC">ODBC</a>, <a href="JDBC" class="mw-redirect" title="JDBC">JDBC</a>, and <a href="ADO.NET" title="ADO.NET">ADO.NET</a>) and a number of special interfaces such as <a href="PHP" title="PHP">PHP</a> and <a href="Perl" title="Perl">Perl</a>. The engine supports <a href="Stored_procedure" title="Stored procedure">stored procedures</a>, user functions (using <a href="Watcom_SQL" class="mw-redirect" title="Watcom SQL">Watcom SQL</a>, <a href="T-SQL" class="mw-redirect" title="T-SQL">T-SQL</a>, <a href="Java_(software_platform)" title="Java (software platform)">Java</a>, or <a href="C_(programming_language)" title="C (programming language)">C</a>/<a href="C%2B%2B" title="C++">C++</a>), <a href="Database_trigger" title="Database trigger">triggers</a>, <a href="Referential_integrity" title="Referential integrity">referential integrity</a>, row-level locking, <a href="Replication_(computer_science)" class="mw-redirect" title="Replication (computer science)">replication</a>, <a href="Cluster_(computing)" class="mw-redirect" title="Cluster (computing)">high availability</a>, <a href="Default_gateway" title="Default gateway">proxy tables</a>, and events (scheduled and system events). <a href="Strong_encryption" class="mw-redirect" title="Strong encryption">Strong encryption</a> is supported for both database files and client-server communication.

</p>

<p>SQL Anywhere is used in several contexts, including as an <a href="Embedded_database" title="Embedded database">embedded database</a>, particularly as an application data store. For example, it is used in <a href="Intuit" title="Intuit">Intuit</a> <a href="QuickBooks" title="QuickBooks">QuickBooks</a>,<sup id="cite_ref-2" class="reference"><a href="#cite_note-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup> in network management products, and in backup products. Its ability to be used with minimal administration is a distinguishing feature in this role.

It can be used as a <a href="Database_server" title="Database server">database server</a> for work groups or for small or medium-sized businesses. It can also function as a <a href="Mobile_database" title="Mobile database">mobile database</a>. It includes scalable <a href="Data_synchronization" title="Data synchronization">data synchronization</a> technology that provides change-based replication between separate databases, including large server-based RDBMS systems.

</p>

<div class="mw-heading mw-heading2"><h2 id="Technologies">Technologies</h2></div>

<p>SQL Anywhere Server is a high performing and embeddable relational database-management system (<a href="Relational_database_management_system" class="mw-redirect" title="Relational database management system">RDBMS</a>) that scales from thousands of users in server environments down to desktop and mobile applications used in widely deployed, zero-administration environments.

</p><p><i>Ultralite</i>: UltraLite is a database-management system designed for small-footprint mobile devices such as PDAs and smart phones.

</p><p><i>Mobilink</i>: MobiLink is a highly-scalable, session-based synchronization technology for exchanging data among relational databases and other non-relational data sources.

</p><p><i>QAnywhere</i>: QAnywhere facilitates the development of robust and secure store-and-forward mobile messaging applications.

</p><p><i>SQL Remote</i>: SQL Remote technology is based on a store and forward architecture that allows occasionally connected users to synchronize data between SQL Anywhere databases using a file or message transfer mechanism.

</p>

<div class="mw-heading mw-heading2"><h2 id="History_2">History</h2></div>

<ul><li>Initially created by <a href="Watcom" title="Watcom">Watcom</a> as <b>Watcom SQL</b>.</li>

<li>Version 3: 1992</li>

<li>Watcom acquired by <a href="Powersoft" title="Powersoft">Powersoft</a> in 1993; Watcom SQL shipped with their visual programming environment <a href="PowerBuilder" title="PowerBuilder">PowerBuilder</a></li>

<li>Version 4: 1994 (<a href="Stored_procedure" title="Stored procedure">Stored procedures</a>, <a href="Database_trigger" title="Database trigger">triggers</a>)</li>

<li>PowerSoft and <a href="Sybase" title="Sybase">Sybase</a> merged in 1995: Watcom SQL was renamed <b>SQL Anywhere</b>.</li>

<li>Version 5: 1995 (SQL Remote <a href="Data_replication" class="mw-redirect" title="Data replication">data replication</a>; graphical administration tools)</li>

<li>Version 6: 1998. Renamed <b>Adaptive Server Anywhere</b> (<b>ASA</b>). (multi-processor support, Java objects in the database)</li>

<li>Version 6.0.2: 1999 (MobiLink <a href="Data_synchronization" title="Data synchronization">data synchronization</a>, UltraLite mobile database for <a href="Palm_OS" title="Palm OS">Palm OS</a> and <a href="Windows_CE" title="Windows CE">Windows CE</a>)</li>

<li>Version 7: 2000 (dynamic <a href="Database_cache" class="mw-redirect" title="Database cache">cache</a>, task scheduling and event handling, cross-platform administration tools)</li>

<li>Version 8: 2001 (Volcano <a href="Query_optimizer" class="mw-redirect" title="Query optimizer">query optimizer</a>, <a href="Encryption" title="Encryption">encrypted</a> data storage and transmission)</li>

<li>Version 9: 2003 (<a href="Index_(database)" class="mw-redirect" title="Index (database)">Index</a> consultant, <a href="Embedded_HTTP_server" title="Embedded HTTP server">embedded HTTP server</a>)</li>

<li>Version 10: 2006 – renamed <b>SQL Anywhere</b> (<a href="High_availability" title="High availability">high availability</a>, intra-query <a href="Parallel_computing" title="Parallel computing">parallelism</a>, <a href="Materialized_view" title="Materialized view">materialized views</a>)<sup id="cite_ref-3" class="reference"><a href="#cite_note-3"><span class="cite-bracket">[</span>3<span class="cite-bracket">]</span></a></sup></li>

<li>Version 11: 2008 (full text search, <a href="BlackBerry" title="BlackBerry">BlackBerry</a> support)<sup id="cite_ref-4" class="reference"><a href="#cite_note-4"><span class="cite-bracket">[</span>4<span class="cite-bracket">]</span></a></sup></li>

<li>Version 12: 2010 released by SAP Sybase (support for <a href="Geodata" class="mw-redirect" title="Geodata">spatial data</a>)<sup id="cite_ref-5" class="reference"><a href="#cite_note-5"><span class="cite-bracket">[</span>5<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-6" class="reference"><a href="#cite_note-6"><span class="cite-bracket">[</span>6<span class="cite-bracket">]</span></a></sup></li>

<li>Version 16: April 18, 2013 – (faster synchronization and improved security)<sup id="cite_ref-7" class="reference"><a href="#cite_note-7"><span class="cite-bracket">[</span>7<span class="cite-bracket">]</span></a></sup></li>

<li>Version 17: July 15, 2015; released by SAP <sup id="cite_ref-8" class="reference"><a href="#cite_note-8"><span class="cite-bracket">[</span>8<span class="cite-bracket">]</span></a></sup></li></ul>

<div class="mw-heading mw-heading2"><h2 id="References">References</h2></div>

/* start https://en.wikipedia.org/ */

.mw-parser-output .reflist{margin-bottom:0.5em;list-style-type:decimal}@media screen{.mw-parser-output .reflist{font-size:90%}}.mw-parser-output .reflist .references{font-size:100%;margin-bottom:0;list-style-type:inherit}.mw-parser-output .reflist-columns-2{column-width:30em}.mw-parser-output .reflist-columns-3{column-width:25em}.mw-parser-output .reflist-columns{margin-top:0.3em}.mw-parser-output .reflist-columns ol{margin-top:0}.mw-parser-output .reflist-columns li{page-break-inside:avoid;break-inside:avoid-column}.mw-parser-output .reflist-upper-alpha{list-style-type:upper-alpha}.mw-parser-output .reflist-upper-roman{list-style-type:upper-roman}.mw-parser-output .reflist-lower-alpha{list-style-type:lower-alpha}.mw-parser-output .reflist-lower-greek{list-style-type:lower-greek}.mw-parser-output .reflist-lower-roman{list-style-type:lower-roman}

/* end https://en.wikipedia.org/ */

</style><div class="reflist">

/* start https://en.wikipedia.org/ */

.mw-parser-output cite.citation{font-style:inherit;word-wrap:break-word}.mw-parser-output .citation q{quotes:"\"""\"""'""'"}.mw-parser-output .citation:target{background-color:rgba(0,127,255,0.133)}.mw-parser-output .id-lock-free.id-lock-free a{background:url("./mw/Lock-green.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-limited.id-lock-limited a,.mw-parser-output .id-lock-registration.id-lock-registration a{background:url("./mw/Lock-gray-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-subscription.id-lock-subscription a{background:url("./mw/Lock-red-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .cs1-ws-icon a{background:url("./mw/Wikisource-logo.svg")right 0.1em center/12px no-repeat}body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-free a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-limited a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-registration a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-subscription a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .cs1-ws-icon a{background-size:contain;padding:0 1em 0 0}.mw-parser-output .cs1-code{color:inherit;background:inherit;border:none;padding:inherit}.mw-parser-output .cs1-hidden-error{display:none;color:var(--color-error,#d33)}.mw-parser-output .cs1-visible-error{color:var(--color-error,#d33)}.mw-parser-output .cs1-maint{display:none;color:#085;margin-left:0.3em}.mw-parser-output .cs1-kern-left{padding-left:0.2em}.mw-parser-output .cs1-kern-right{padding-right:0.2em}.mw-parser-output .citation .mw-selflink{font-weight:inherit}@media screen{.mw-parser-output .cs1-format{font-size:95%}html.skin-theme-clientpref-night .mw-parser-output .cs1-maint{color:#18911f}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .cs1-maint{color:#18911f}}

/* end https://en.wikipedia.org/ */

</style><cite class="citation interview cs1"><a rel="nofollow" class="external text" href="https://archive.computerhistory.org/resources/access/text/2013/05/102702565-05-01-acc.pdf">"RDBMS Workshop: Ingres and Sybase"</a> <span class="cs1-format">(PDF)</span> (Interview). Interviewed by Doug Jerger. Computer History Museum. 2007-06-13<span class="reference-accessdate">. Retrieved <span class="nowrap">2025-05-30</span></span>.</cite></span>

</li>

<li id="cite_note-2"><span class="mw-cite-backlink"><b><a href="#cite_ref-2">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://www.sybase.com/detail?id=1061721">"QuickBooks replaces its flat file system with SQL Anywhere from Sybase iAnywhere"</a>. Sybase.</cite></span>

</li>

<li id="cite_note-3"><span class="mw-cite-backlink"><b><a href="#cite_ref-3">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://www.sybase.com/detail?id=1042264">"Sybase iAnywhere Announces the Release of SQL Anywhere 10"</a>. Sybase press release. August 7, 2006.</cite></span>

</li>

<li id="cite_note-4"><span class="mw-cite-backlink"><b><a href="#cite_ref-4">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://www.sybase.com/detail?id=1057559">"Sybase iAnywhere Announces Availability of SQL Anywhere 11"</a>. Sybase press release. August 5, 2008.</cite></span>

</li>

<li id="cite_note-5"><span class="mw-cite-backlink"><b><a href="#cite_ref-5">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://www.sybase.com/detail?id=1080500">"Sybase Advances its Mobile and Embedded Database Leadership Position with SQL Anywhere 12"</a>. Sybase press release. June 29, 2010.</cite></span>

</li>

<li id="cite_note-6"><span class="mw-cite-backlink"><b><a href="#cite_ref-6">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://www.sap.com/index.html">"SAP Software Solutions | Business Applications and Technology"</a>. <i>SAP</i>.</cite></span>

</li>

<li id="cite_note-7"><span class="mw-cite-backlink"><b><a href="#cite_ref-7">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20140211065159/http://www.kessler.de/prd/sybase/Ianywhere16.pdf">"Archived copy"</a> <span class="cs1-format">(PDF)</span>. Archived from <a rel="nofollow" class="external text" href="http://www.kessler.de/prd/sybase/Ianywhere16.pdf">the original</a> <span class="cs1-format">(PDF)</span> on 2014-02-11<span class="reference-accessdate">. Retrieved <span class="nowrap">2013-07-01</span></span>.</cite><span class="cs1-maint citation-comment"><code class="cs1-code">{{cite web}}</code>: CS1 maint: archived copy as title (link)</span></span>

</li>

<li id="cite_note-8"><span class="mw-cite-backlink"><b><a href="#cite_ref-8">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://blogs.sap.com/2015/07/15/announcing-sql-anywhere-17-2/">"Announcing SQL Anywhere 17! | SAP Blogs"</a>. <i>blogs.sap.com</i>.</cite></span>

</li>

</ol></div></div>

<div class="mw-heading mw-heading2"><h2 id="External_links">External links</h2></div>

<ul><li><a rel="nofollow" class="external text" href="https://www.sap.com/products/sql-anywhere.html">SQL Anywhere official product page</a></li></ul></div><div><div class="zim-footer">

This article is issued from <a class="external text" title="Last edited on 2025-06-01" href="https://en.wikipedia.org/wiki/?title=SQL_Anywhere&oldid=1293342147">Wikipedia</a>. The text is available under <a class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.en">Creative Commons Attribution-Share Alike 4.0</a> unless otherwise noted. Additional terms may apply for the media files.

</div>

</div></div>

</div>

</main>

</div>

</body></html>